package com.qf.mapper;

import com.qf.entity.Brand;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface PhoneBrandMapper {

    @Select("select tb_brand.* from  tb_brand\n" +
            "left join tb_category_brand tcb on tb_brand.brand_id = tcb.fk_brand_id\n" +
            "left join tb_category tc on tcb.fk_category_id = tc.category_id\n" +
            "where tc.category_id=#{catID}")
    List<Brand> findByCatId(String catID);
}
